Executive Summary 3



Troubles that occurred during the project:

  1. The Package Failed due to the error – Data conversion of the Location 1 returned status value 4 and status text “ Text was truncated or one …..”  resolved this by changing the output column length to 4000 for the Location 1 column in the Source.
  2. Data cleanup for the Victim Business Name –the column has many special characters and address or date instead of name of the business, for example column has “7-Jul” instead of 7 Eleven … resolved this issue with update SQL Query. 


Designing a Data Warehouse for Cyber Crimes

https://commons.erau.edu/cgi/viewcontent.cgi?article=1001&context=adfsl